Term 
EntityType  Independent 
Logical Entity Name  Term 
Default Table Name  AdTerm 
Logical Only  NO 
Definition 
 
Note 
 

Term Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
Code    CHAR(16)  NO 
 
Name    CHAR(35)  NO 
 
CampusGroupId    INTEGER  NO 
 
StartDate    DATETIME  YES 
 
EndDate    DATETIME  YES 
 
ShiftId    INTEGER  NO 
 
ModFlag    CHAR(1)  NO 
 
IsActive    BIT  NO 
 
LastModifiedUserId    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
TermId(PK)    INTEGER  NO 
 
IsGlobalExtractTerm    BIT  YES 
 
AddDropDate    DATETIME  YES 
 
StudentRegisterEndDate    DATETIME  YES 
 
StudentRegisterStartDate    DATETIME  YES 
 
RevenueUnits    NUMERIC(5, 2)  YES 
 
IsTermOpen    BIT  NO 
 
IsAttendanceRecorded    BIT  NO 
 
OpenRegistrationBeginDateTime    DATETIME  YES 
 
OpenRegistrationEndDateTime    DATETIME  YES 
 
InternalRegistrationBeginDateTime    DATETIME  YES 
 
InternalRegistrationEndDateTime    DATETIME  YES 
 
IsChildTermDatesRuleEnforced    BIT  NO 
 
IsSapTerm    BIT  NO 
 
TermUsage    SMALLINT  NO 
 
SendCourseSectionDataToLms    BIT  NO 
 
SendCourseSectionDataInitialDoneToLms    BIT  NO 
 
SendInstructorAssignmentsToLms    BIT  NO 
 
SendInstructorAssignmentsInitialDoneToLms    BIT  NO 
 
SendStudentRegistrationDataToLms    BIT  NO 
 
SendStudentRegistrationDataInitialDoneToLms    BIT  NO 
 
AuditDesignationDeadline    DATETIME  YES 
 
CourseRefundPolicyId    INTEGER  YES 
 
IsTermSuspendLiftedCampusLinkAmbassador    BIT  NO 
 
SapCalcDaysAfterTermEnd    INTEGER  YES 
 
IsOnlineUsageAllowed    BIT  NO 
 
IsLdaRetainedUnregisteredCourses    BIT  YES 
 
ScheduleChangesType    CHAR(1)  YES 
 
NumberOfDaysToRecalcNotification    INTEGER  YES 
 
IsPrePullRequiredForGlobal    BIT  NO 
 
NumberOfDaysPriorToTermStartDate    INTEGER  YES 
 
NumberOfDaysAfterTermStartDate    INTEGER  YES 
 
IsStandardTerm    TINYINT  NO 
 
StandardTermType    CHAR(1)  YES 
 
FaAcademicCalendar    SMALLINT  YES 
 
IsExcludedCrmIntegration    BIT  NO 
 
TermGroupId(FK)    INTEGER  YES 
 
SummerHeaderOrTrailer    TINYINT  NO 
 

Term Keys 
Key Name  Key Type  Keys 
AdTerm_StartDate_N_N_IDX  Inversion Entry  StartDate 
AdTerm_DateLstMod_N_N_IDX  Inversion Entry  LastModifiedDateTime 
AdTerm_Code_N_N_IDX  Inversion Entry  Code 
AdTerm_TermUsage_N_N_IDX  Inversion Entry  TermUsage 
AdTerm_AdTermID_StartDate_EndDate_N_N_IDX  Inversion Entry  TermId, StartDate, EndDate 
AdTerm_Active_SyCampusGrpId_AdTermId_U_N_IDX  Alternate Key  IsActive, CampusGroupId, TermId 
AdTerm_AdTermID_U_C_IDX  PrimaryKey  TermId 
AdTerm_TermUsage_SyCampusGrpId_Descrip_Code_AdTermID_StartDate_EndDate_Active_TermOpen_U_N_IDX  Alternate Key  TermUsage, CampusGroupId, Name, Code, TermId, StartDate, EndDate, IsActive, IsTermOpen 

Term Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
TermGroup  Non-Identifying  Zero or One to Zero or More        TermGroupId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
ClassSectionTerm  Non-Identifying  One To Zero or More          NO 
TermRelationshipDataChange  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentTermConfirmation  Non-Identifying  One To Zero or More          NO 
TermRelationshipDataChange  Non-Identifying  Zero or One to Zero or More          NO 
StudentTransferCredit  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentPeriodHonor  Non-Identifying  One To Zero or More          NO 
StudentCoursePendingRegistration  Non-Identifying  One To Zero or More          NO 
AdEnrollRegistrationGroup  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentPeriodRegistrationTerm  Non-Identifying  One To Zero or More          NO 
StudentCourseStatusChange  Non-Identifying  One To Zero or More          NO 
AdEnrollSchedStatusHistory  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentTermRelationship  Non-Identifying  One To Zero or More          NO 
StudentGpa  Non-Identifying  One To Zero or More          NO 
StudentGpa  Non-Identifying  One To Zero or More          NO 
RegistrationGroupTerm  Non-Identifying  One To Zero or More          NO 
RegistrationRule  Non-Identifying  One To Zero or More          NO 
FaSapProcessQueueDetailRecord  Non-Identifying  One To Zero or More          NO 
SchoolStartDateTerm  Non-Identifying  One To Zero or More          NO 
AdStudentTermSequenceHeader  Non-Identifying  One To Zero or More          NO 
AdTermCampusRelationship  Non-Identifying  One To Zero or More          NO 
adTermExternalMap  Non-Identifying  One To Zero or More          NO 
TermRegistrationSetting  Non-Identifying  One To Zero or More          NO 
TermProgramAssociation  Non-Identifying  One To Zero or More          NO 
AdTermProgramAssociation  Non-Identifying  One To Zero or More          NO 
TermRelationship  Non-Identifying  One To Zero or More          NO 
TermRelationship  Non-Identifying  One To Zero or More          NO 
TermRelationshipDataChange  Non-Identifying  One To Zero or More          NO 
TermRelationshipDataChange  Non-Identifying  One To Zero or More          NO 
TermRelationshipDataChange  Non-Identifying  One To Zero or More          NO 
AdTermSequenceStartDate  Non-Identifying  One To Zero or More          NO 
AmCollegeTransferAdvance  Non-Identifying  One To Zero or More          NO 
Deposit  Non-Identifying  One To Zero or More          NO 
StudentCourseDocumentPermit  Non-Identifying  One To Zero or More          NO 
FaCostOfAttendanceTermRepackagingConfig_FAA  Non-Identifying  One To Zero or More          NO 
FaGlobalExtractChildTerm  Non-Identifying  One To Zero or More          NO 
StudentAwardNonTitleIvPaymentPeriod  Non-Identifying  One To Zero or More          NO 
FaTermTrack  Non-Identifying  One To Zero or More          NO 
FaTermTrackProgramAssociation  Non-Identifying  One To Zero or More          NO 
HsRoomMateMatchCriteria  Non-Identifying  One To Zero or More          NO 
HousingLeaseScheduledCharge  Non-Identifying  One To Zero or More          NO 
HousingLease  Non-Identifying  One To Zero or More          NO 
HousingLease  Non-Identifying  One To Zero or More          NO 
AutomaticBillingBatchDetail  Non-Identifying  One To Zero or More          NO 
StudentBillingStatementBatch  Non-Identifying  One To Zero or More          NO 
StudentRevenueSummaryChildTerm  Non-Identifying  One To Zero or More          NO 
StudentAccountPendingTransaction  Non-Identifying  One To Zero or More          NO 
StudentAccountPendingTransactionCourse  Non-Identifying  One To Zero or More          NO 
SaPendingChargeRecalcLog  Non-Identifying  One To Zero or More          NO 
SaRegBillQueue_Detail  Non-Identifying  One To Zero or More          NO 
StudentRevenueDetail  Non-Identifying  One To Zero or More          NO 
SaStudentLedgerTermUpdatesArchive  Non-Identifying  One To Zero or More          NO 
StudentSubsidiaryAccountTransaction  Non-Identifying  One To Zero or More          NO 
StudentSubsidiaryAccountRefund  Non-Identifying  One To Zero or More          NO 
StudentAccountTransactionCourse  Non-Identifying  One To Zero or More          NO 
SaTransCourseAmount  Non-Identifying  One To Zero or More          NO 
StudentAthleticDetail  Non-Identifying  One To Zero or More          NO 
StudentServiceType  Non-Identifying  One To Zero or More          NO 
StudentVeteranDetail  Non-Identifying  One To Zero or More          NO 
SyIndicatorStudentRelation  Non-Identifying  One To Zero or More          NO 
StudentSchoolStatusHistory  Non-Identifying  One To Zero or More          NO 
StateReportConfigurationSettingTerm  Non-Identifying  One To Zero or More          NO 
StudentCourseStatusChange  Non-Identifying  One To Zero or More          NO 
StudentAccountTransaction  Non-Identifying  One To Zero or More          NO 
TermRelationshipDataChange  Non-Identifying  One To Zero or More          NO 
AutomaticBillingBatchDetail  Non-Identifying  One To Zero or More          NO 
PaidDisbursement  Non-Identifying  One To Zero or More          NO 
Refund  Non-Identifying  One To Zero or More          NO 
RegistrationGroupTerm  Non-Identifying  One To Zero or More          NO 
ScheduledDisbursement  Non-Identifying  One To Zero or More          NO 
StudentAccountPendingTransaction  Non-Identifying  One To Zero or More          NO 
StudentAccountPendingTransactionRegisteredClass  Non-Identifying  One To Zero or More          NO 
StudentAccountTransaction  Non-Identifying  One To Zero or More          NO 
StudentAccountTransactionCourse  Non-Identifying  One To Zero or More          NO 
StudentBillingStatementBatch  Non-Identifying  One To Zero or More          NO 
StudentCourse  Non-Identifying  One To Zero or More          NO 
StudentCourseDocumentPermit  Non-Identifying  One To Zero or More          NO 
StudentCoursePendingRegistration  Non-Identifying  One To Zero or More          NO 
StudentCourseStatusChange  Non-Identifying  One To Zero or More          NO 
StudentDegreePathway  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentPeriodHonor  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentPeriodLesson  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentPeriodRegistrationTerm  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentTermSummary  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentTermSummaryRebuildLog  Non-Identifying  One To Zero or More          NO 
StudentGpa  Non-Identifying  One To Zero or More          NO 
StudentGpaIncludedCourse  Non-Identifying  One To Zero or More          NO 
StudentRefundCalculation  Non-Identifying  One To Zero or More          NO 
StudentRt4Calculation  Non-Identifying  One To Zero or More          NO 
StudentSubsidiaryAccountRefund  Non-Identifying  One To Zero or More          NO 
StudentSubsidiaryAccountTransaction  Non-Identifying  One To Zero or More          NO 
StudentTransferCredit  Non-Identifying  One To Zero or More          NO 
TermGroup  Non-Identifying  One To Zero or More          NO 
TermProgramAssociation  Non-Identifying  One To Zero or More          NO 
TermRegistrationSetting  Non-Identifying  One To Zero or More          NO 
TermRelationship  Non-Identifying  One To Zero or More          NO 
TermRelationship  Non-Identifying  One To Zero or More          NO 

Term Check Constraints 
Check Constraint Name  CheckConstraint 
Chk_AdTerm_OpenRegistrationBeginDateTime_OpenRegistrationEndDateTime  ([OpenRegistrationBeginDateTime] is null and [OpenRegistrationEndDateTime] is null or [OpenRegistrationBeginDateTime] is not null and [OpenRegistrationEndDateTime] is not null and [OpenRegistrationBeginDateTime] <= [OpenRegistrationEndDateTime]) 
Chk_AdTerm_InternalRegistrationBeginDateTime_InternalRegistrationEndDateTime  ([InternalRegistrationBeginDateTime] is null and [InternalRegistrationEndDateTime] is null or [InternalRegistrationBeginDateTime] is not null and [InternalRegistrationEndDateTime] is not null and [InternalRegistrationBeginDateTime] <= [InternalRegistrationEndDateTime])